package com.qjdchina.sku.dao.mapper;

import com.qjdchina.sku.model.CategoryBrandAssociate;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * Created by Luoyan on 2017/5/23.
 */
public interface CategoryBrandAssociateMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(CategoryBrandAssociate record);

    int insertSelective(CategoryBrandAssociate record);

    CategoryBrandAssociate selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(CategoryBrandAssociate record);

    int updateByPrimaryKey(CategoryBrandAssociate record);

    List<CategoryBrandAssociate> selectByCategoryBrandIdsAndItemIds(@Param("skuCategoryBrandIdList") List<Integer> skuCategoryBrandIdList,
                                                                   @Param("skuItemIdList") List<Integer> skuItemIdList);

    List<CategoryBrandAssociate> selectByCategoryBrandIdAndItemIds(@Param("skuCategoryBrandId") Integer skuCategoryBrandId,
                                                                    @Param("skuItemIdList") List<Integer> skuItemIdList);

    List<CategoryBrandAssociate> selectByCategoryBrandIdAndRegionIds(@Param("skuCategoryBrandId") Integer skuCategoryBrandId,
                                                                   @Param("skuRegionIdList") List<Integer> skuRegionIdList);
}
